How to: Locate circular references.
Solution:
Select a cell involved in a circular reference. Select the 'Edit' menu and select 'Go To...'. Select the 'Precedents' and 'All Levels' radio buttons in the 'Go To Special' dialog box.
1) Select the cell whose cell reference is displayed as being circular in the status bar.
2) Select the 'Edit' menu and select 'Go To...'. (The Go To dialog box appears.)
3) Click 'Special...'. (The Go To Special dialog box appears.)
4) Select the 'Precedents' radio button.
5) Select the 'All Levels' radio button.
the Precedents and the All Levels radio buttons
6) Click 'OK'. (The cells involved in the circular reference are highlighted.)
